More types of record selection formulas can be pushed down
to the server

In particular, there is now support for pushing down a record selection formula that involves the IsNull function and the Or operator. For example, the following selection formulas can be pushed down:

{Orders.Order ID} < 1020 Or 
{Orders.Order Amount} >= 1000

IsNull ({Customer.Region}) Or {Customer.Region} = "BC"

The formula language now also performs simplification of most constant and parameter expressions in formulas at compile time rather than formula evaluation time. What this means is that record selection formulas such as:

{date field} > CurrentDate - 3

{date field} In CDate ({?year parameter}, 6, 1) To
                CDate ({?year parameter}, 9, 30)

can be pushed down to the server since the expressions in italics are replaced by their values when the formula is compiled, and the resulting formula can then be converted to a SQL query.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com